CREATE TABLE Office (
OfficeID VARCHAR(5), NOT NULL,
OfficeName CHAR(50), NOT NULL,
Address VARCHAR(100), NOT NULL,
CityID VARCHAR(5), NOT NULL,
Postcode VARCHAR(10), NOT NULL,
PhoneNum VARCHAR(15), NOT NULL,
ManagerName CHAR(50), NOT NULL );